[dbo].[Exhb

Property	Value
Created	3:12:19 PM Friday, January 07, 2011
Last Modified	11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Key iExhb_RegID: EXHB_ID\LAST_NAME\FIRST_NAME$	EXHB_ID	varchar(10)	10	('')
	MEET_ID	varchar(10)	10	('')
	REG_ID	varchar(10)	10	('')
	STATUS	varchar(2)	2
	PAYTYPE	varchar(1)	1
$Cluster Key iExhb_RegID: EXHB_ID\LAST_NAME\FIRST_NAME$	FIRST_NAME	varchar(20)	20
$Cluster Key iExhb_RegID: EXHB_ID\LAST_NAME\FIRST_NAME$	LAST_NAME	varchar(30)	30
	CITY	varchar(40)	40
	STATE_PROVINCE	varchar(15)	15
	COUNTRY	varchar(25)	25
	BADGE_FIRST	varchar(30)	30
	BADGE_SECOND	varchar(30)	30
	BADGE_THIRD	varchar(30)	30
	BADGE_FOURTH	varchar(30)	30
	BADGE_FIFTH	varchar(30)	30
	KEY_CONTACT	varchar(1)	1
	COMMENTS	text	max
	GST_PAYSTAT	varchar(1)	1
	DATE_ENTERED	datetime	8
	DATE_UPDATE	datetime	8
	PRODUCT_CODE	varchar(31)	31
	NAME_ID	varchar(10)	10
	TIME_STAMP	timestamp	8

	Name	Columns
$Cluster Key iExhb_RegID: EXHB_ID\LAST_NAME\FIRST_NAME$	iExhb_RegID	EXHB_ID, LAST_NAME, FIRST_NAME

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

SQL Script

CREATE TABLE [dbo].[Exhb_Reg]
(
[EXHB_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Exhb_Reg_EXHB_ID] DEFAULT (''),
[MEET_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Exhb_Reg_MEET_ID] DEFAULT (''),
[REG_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Exhb_Reg_REG_ID] DEFAULT (''),
[STATUS] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAYTYPE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FIRST_NAME] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LAST_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BADGE_FIRST] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BADGE_SECOND] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BADGE_THIRD] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BADGE_FOURTH] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BADGE_FIFTH] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KEY_CONTACT] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COMMENTS] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GST_PAYSTAT] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DATE_ENTERED] [datetime] NULL,
[DATE_UPDATE] [datetime] NULL,
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NAME_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE CLUSTERED INDEX [iExhb_RegID] ON [dbo].[Exhb_Reg] ([EXHB_ID], [LAST_NAME], [FIRST_NAME]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Exhb_Reg] TO [IMIS]
GRANT SELECT ON  [dbo].[Exhb_Reg] TO [IMIS]
GRANT INSERT ON  [dbo].[Exhb_Reg] TO [IMIS]
GRANT DELETE ON  [dbo].[Exhb_Reg] TO [IMIS]
GRANT UPDATE ON  [dbo].[Exhb_Reg] TO [IMIS]
GO